/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 1811

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 43 41 53 |CHILD UP|DATE CAS|
|00000010| 43 41 44 45 00 20 20 2d | 2d 20 45 52 77 69 6e 20 |CADE.  -|- ERwin |
|00000020| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00000030| 65 20 0d 0a 20 20 2d 2d | 20 25 50 61 72 65 6e 74 |e ..  --| %Parent|
|00000040| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00000050| 69 6c 64 20 4f 4e 20 43 | 48 49 4c 44 20 55 50 44 |ild ON C|HILD UPD|
|00000060| 41 54 45 20 43 41 53 43 | 41 44 45 20 0d 0a 20 20 |ATE CASC|ADE ..  |
|00000070| 20 20 69 6e 73 65 72 74 | 20 69 6e 74 6f 20 25 50 |  insert| into %P|
|00000080| 61 72 65 6e 74 20 28 25 | 50 61 72 65 6e 74 50 4b |arent (%|ParentPK|
|00000090| 28 22 2c 22 2c 29 29 0d | 0a 20 20 20 20 20 20 73 |(",",)).|.      s|
|000000a0| 65 6c 65 63 74 20 25 43 | 68 69 6c 64 46 4b 28 22 |elect %C|hildFK("|
|000000b0| 2c 22 2c 29 0d 0a 20 20 | 20 20 20 20 20 20 66 72 |,",)..  |      fr|
|000000c0| 6f 6d 20 25 43 68 69 6c | 64 0d 0a 20 20 20 20 20 |om %Chil|d..     |
|000000d0| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 |   where|..      |
|000000e0| 20 20 20 20 2d 2d 20 25 | 25 4e 6f 74 6e 75 6c 6c |    -- %|%Notnull|
|000000f0| 46 4b 28 25 4e 65 77 2c | 22 20 69 73 20 6e 6f 74 |FK(%New,|" is not|
|00000100| 20 6e 75 6c 6c 20 61 6e | 64 22 29 20 0d 0a 20 20 | null an|d") ..  |
|00000110| 20 20 20 20 20 20 20 20 | 25 4e 6f 74 6e 75 6c 6c |        |%Notnull|
|00000120| 46 4b 28 25 4e 65 77 2c | 22 20 69 73 20 6e 6f 74 |FK(%New,|" is not|
|00000130| 20 6e 75 6c 6c 20 61 6e | 64 22 29 0d 0a 20 20 20 | null an|d")..   |
|00000140| 20 20 20 20 20 20 20 6e | 6f 74 20 65 78 69 73 74 |       n|ot exist|
|00000150| 73 20 28 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |s (..   |        |
|00000160| 20 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 25 | select |* from %|
|00000170| 50 61 72 65 6e 74 0d 0a | 20 20 20 20 20 20 20 20 |Parent..|        |
|00000180| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 |      wh|ere..   |
|00000190| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 2d 2d 20 |        |     -- |
|000001a0| 25 25 4a 6f 69 6e 46 4b | 50 4b 28 25 4e 65 77 2c |%%JoinFK|PK(%New,|
|000001b0| 25 50 61 72 65 6e 74 2c | 22 20 3d 20 22 2c 22 20 |%Parent,|" = "," |
|000001c0| 61 6e 64 22 29 20 0d 0a | 20 20 20 20 20 20 20 20 |and") ..|        |
|000001d0| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 |        |%JoinFKP|
|000001e0| 4b 28 25 4e 65 77 2c 25 | 50 61 72 65 6e 74 2c 22 |K(%New,%|Parent,"|
|000001f0| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 0d 0a 20 20 | = "," a|nd")..  |
|00000200| 20 20 20 20 20 20 20 20 | 29 3b 0d 0a 00 1d 27    |        |);....' |
+--------+-------------------------+-------------------------+--------+--------+